Knowledge has a beginning but no end

GSTR 1 Excel Report Criteria

Akhilesh Verma

2024-02-12 16:27:52
Worksheet Name Reference Help Instruction
b2b B2B Supplies Details of invoices of Taxable supplies made to other registered taxpayers




 
b2cl B2C Large Invoices for Taxable outward supplies to consumers where
a)The place of supply is outside the state where the supplier is registered and
b)The total invoice value is more that Rs 2,50,000
b2cs B2C Small Supplies made to consumers and unregistered persons of the following nature
a) Intra-State: any value
b) Inter-State: Invoice value Rs 2.5 lakh or less
cdnr Credit/ Debit Note Credit/ Debit Notes/Refund vouchers issued to the registered taxpayers during the tax period. Debit or credit note issued against invoice will be reported here against original invoice, hence fill the details of original invoice also which was furnished in B2B,B2CL section of earlier/current period tax period.
cdnur Credit/ Debit Note for unregistered Persons Credit/ Debit Notes/Refund vouchers issued to the unregistered persons against interstate invoice value is  more than Rs 2.5 lakh
exp Export Exports supplies including supplies to SEZ/SEZ Developer or deemed exports (When Invoice Type is Export in Sales Invoice)
at Tax liability on advances Tax liability arising on account of receipt of consideration  for which  invoices have not been issued in the same tax period.
atadj Advance adjustments Adjustment of tax liability for tax already paid  on advance receipt of consideration and invoices issued in the current period for the supplies. 
exemp Nil Rated, Exempted and Non GST supplies Details of Nil Rated, Exempted and Non GST Supplies made during the tax period
(On Selection of Nil rated, Exempted, Zero Tax code in Sales invoice)
hsn HSN Summary HSN wise summary of goods /services supplied during the tax period
docs List of Documents issued Details of various documents issued by the taxpayer during the tax period


Related Articles
  • What is GST Number
  • GST e-Invoicing Process
  • GST return form in StrategicERP
  • GSTR 2A Mismatch Report
  • Statutory Management - GST Updates
  • Purchase Bill --> GST rate on transport Cost differ from Item GST rate
  • Search Taxpayer (GSTIN) details through IRIS API Integration
  • GST Electronic Challan Calculator
  • GST Dashboard
  • GSTR2B Reconciliation Statement - Upload only 2B Json File as 2A Json is Optional
  • GSTR 1 Offline Utility to File Return
  • Vendor Or Client Details Autofill In Vendor Master Form On GSTIN Basis
  • GSTR 2 Excel Criteria